{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["přihlášení","Tabulky","Pavouk","Pořadí"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"přihlášení","index":0,"n_rows":21,"n_cols":16,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["# hráče","jméno","nasazený",null,"Přehled",null,null,null,null,null,null,null,null,null,null,"21:10:00"]
[{"$f":"ROW()-1","v":1},"Tománková Denisa",true,null,{"$f":"IF(OR(F4=11,F4<=7),\"Pozor, pro \"&F4&\" přihlášených hráčů není určená logika rozdělení!\",\"\")","v":""}]
[2,"Pěnčíková Tereza",true,null,{"$f":"IF(rg_počet_nasazených>rg_pocet_skupin,\"Pozor, počet nasazených je vyšší, než počet skupin. Není připravená logika.\",\"\")","v":""}]
[3,"Jelínková Adéla",true,null,"počet přihlášených:",{"$f":"COUNTA(tbl_seznam_hracu[jméno])","v":20}]
[4,"Staňková Laura",true,null,"počet nasazených:",{"$f":"COUNTIFS(tbl_seznam_hracu[nasazený],TRUE)","v":5}]
[5,"Krejčíková Viktorie",true,null,"počet skupin:",{"$f":"ROUNDDOWN(F4/4,0)","v":5}]
[6,"Korencová Hana",false,null,"počet 5-ti členných skupin:",{"$f":"MOD(F4,4)","v":0}]
[7,"Petrásek Ella Martina",false]
[8,"Hadrabová Radka",false]
[9,"Jančaříková Anna",false]
[10,"Michna Lisa",false]
[11,"Halfarová Eva",false,null,"Tabulka se seznamem hráčů musí být seřazena tak, že na začátku seznamu jsou nasazení hráči."]
[{"$f":"ROW()-1","v":12},"Hugová Kateřina",false]
[{"$f":"ROW()-1","v":13},"Boudová Johana",false]
[14,"Gabrielová Edita Luisa",false]
[15,"Svoboda Adéla",false]
[16,"Marešová Beata",false]
[17,"Duchoňová Alice",false]
[18,"Merunová Veronika",false]
[19,"Blechová Amálka",false]
[20,"Stáňová Šárka",false]

{"sheet":"Tabulky","index":1,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
["Skupina A - kurt ",null,"Tománková Denisa","Petrásek Ella Martina","Boudová Johana","Halfarová Eva","Pořadí","Počet vítězství"]
["A1","Tománková Denisa",null,"4-0","4-0","4-0","1.","3"]
["A2","Petrásek Ella Martina","0-4",null,"4-1","1-4","3.","1"]
["A3","Boudová Johana","0-4","1-4",null,"1-4","4.","0"]
["A4","Halfarová Eva","0-4","4-1","4-1",null,"2.","2"]
["Skupina B -  kurt ",null,"Pěnčíková Tereza","Michna Lisa","Blechová Amálka","Merunová Veronika","Pořadí","Počet vítězství"]
["B1","Pěnčíková Tereza",null,"4-2","4-1","4-1","1.","3"]
["B2","Michna Lisa","2-4",null,"4-1","4-0","2.","2"]
["B3","Blechová Amálka","1-4","1-4",null,"4-1","3.","1"]
["B4","Merunová Veronika","1-4","0-4","1-4",null,"4.","0"]
["Skupina C - kurt ",null,"Jelínková Adéla","Marešová Beata","Stáňová Šárka","Gabrielová Edita Luisa","Pořadí","Počet vítězství"]
["C1","Jelínková Adéla",null,"4-0","4-3","4-0","1.","3"]
["C2","Marešová Beata","0-4",null,"2-4","2-4","4.","0"]
["C3","Stáňová Šárka","3-4","4-2",null,"4-1","2.","2"]
["C4","Gabrielová Edita Luisa","0-4","4-2","1-4",null,"3.","1"]
["Skupina D - kurt ",null,"Staňková Laura","Jančaříková Anna","Hadrabová Radka","Duchoňová Alice","Pořadí","Počet vítězství"]
["D1","Staňková Laura",null,"4-1","4-3","4-0","1.","3"]
["D2","Jančaříková Anna","1-4",null,"1-4","4-0","3.","1"]
["D3","Hadrabová Radka","3-4","4-1",null,"4-0","2.","2"]
["D4","Duchoňová Alice","0-4","0-4","0-4",null,"4.","0"]
["Skupina E - kurt",null,"Krejčíková Viktorie","Hugová Kateřina","Korencová Hana","Svoboda Adéla","Pořadí","Počet vítězství"]
["E1","Krejčíková Viktorie",null,"4-0","4-1","4-0","1.","3"]
["E2","Hugová Kateřina","0-4",null,"0-4","3-4","4.","0"]
["E3","Korencová Hana","1-4","4-0",null,"4-1","2.","2"]
["E4","Svoboda Adéla","0-4","4-3","1-4",null,"3.","1"]
["E5",0,"1-4","3-4","4-0","4-0"]
[]
["Skupina F - kurt",null,0,0,0,0,"Pořadí","Počet vítězství"]
["F1",0,null,0,0,0]
["F2",0,null,null,0,0]
["F3",0,null,null,null,0]
["F4",0]
["F5",0]
[]
["Skupina G - kurt ",null,0,0,0,0,"Pořadí","Počet vítězství"]
["G1",0,null,0,0,0]
["G2",0,null,null,0,0]
["G3",0,null,null,null,0]
["G4",0]
["G5",0]
[]
["Skupina H - kurt ",null,0,0,0,0,"Pořadí","Počet vítězství"]
["H1",0,null,0,0,0]
["H2",0,null,null,0,0]
["H3",0,null,null,null,0]
["H4",0]
["H5",0]
[]
["Skupina I - kurt ",null,0,0,0,0,"Pořadí","Počet vítězství"]
["I1",0,null,0,0,0]
["I2",0,null,null,0,0]
["I3",0,null,null,null,0]
["I4",0]
["I5",0]
[]
["Skupina J - kurt ",null,0,0,0,0,"Pořadí","Počet vítězství"]
["J1",0,null,0,0,0]
["J2",0,null,null,0,0]
["J3",0,null,null,null,0]
["J4",0]
["J5",0]

{"sheet":"Pavouk","index":2,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Tománková Denisa"]
[]
[null,null,"Tománková Denisa"]
["Stáňová Šárka",null,"4-1"]
[null,"Stáňová Šárka"]
["Korencová Hana","4-0"]
[null,null,null,"Tománková Denisa"]
[null,null,null,"4-0"]
[null,"Michna Lisa"]
[]
[null,null,"Michna Lisa"]
[null,null,"4-2"]
[null,"Staňková Laura"]
[]
[null,null,null,"Tománková Denisa"]
[null,null,null,"4-2"]
[null,"Jelinková Adéla"]
[]
[null,null,"Jelínková Adéla"]
[null,null,"4-3"]
[null,"Krejčíková Viktorie"]
[]
[null,null,null,"Jelínková"]
["Hadrabová Radka",null,null,"4-0"]
[null,"Halfarová Eva"]
["Halfarová Eva","4-2"]
[null,null,"Halfarová Eva"]
[null,null,"4-3"]
[null,"Pěnčíková Tereza"]

{"sheet":"Pořadí","index":3,"n_rows":61,"n_cols":8,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["POŘADÍ - SPARTA HEAD BABYTENIS TOUR LÉTO 2020 - DÍVKY"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Pořadí","Příjmení","1. turnaj","2. turnaj","3. turnaj","4. turnaj","Masters","Celkem"]
["1.","Tománková Denisa",300,null,null,null,null,{"$f":"SUM(C25:G25)","v":300}]
["2.","Jelínková Adéla",250,null,null,null,null,{"$f":"C26+D26","v":250}]
["3.- 4.","Halfarová Eva",200,null,null,null,null,{"$f":"C27+D27","v":200}]
[null,"Michna Lisa",200,null,null,null,null,{"$f":"C28+D28","v":200}]
["5.-8.","Stáňová šárka",100,null,null,null,null,{"$f":"SUM(C29:G29)","v":100}]
[null,"Staňková Laura",100,null,null,null,null,100]
[null,"Krejčíková Viktorie",100,null,null,null,null,100]
[null,"Pěnčíková Tereza",100,null,null,null,null,100]
["9.-10.","Korencová Hana",50,null,null,null,null,50]
[null,"Hadrabová radka",50,null,null,null,null,50]
["11.-14.","Petrásek Ella",20,null,null,null,null,20]
[null,"Blechová Amálka",20,null,null,null,null,20]
[null,"Gabrielová Edita",20,null,null,null,null,{"$f":"SUM(C37:G37)","v":20}]
[null,"Jančaříková Anna",20,null,null,null,null,{"$f":"C38+D38","v":20}]
[null,"Svoboda Adéla",20,null,null,null,null,{"$f":"SUM(C39:G39)","v":20}]
["17.- 20.","Hugová Kateřina",10,null,null,null,null,{"$f":"SUM(C40:G40)","v":10}]
[null,"Merunová Veronika",10,null,null,null,null,{"$f":"SUM(C41:G41)","v":10}]
[null,"Marešová Beata",10,null,null,null,null,{"$f":"C42+D42","v":10}]
[null,"Duchoňová Alice",10,null,null,null,null,{"$f":"SUM(C43:G43)","v":10}]
[null,"Boudová Johana",10,null,null,null,null,{"$f":"SUM(C44:G44)","v":10}]
[null,null,null,null,null,null,null,{"$f":"C45+D45","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(C46:G46)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(C47:G47)","v":0}]
[null,null,null,null,null,null,null,{"$f":"C48+D48","v":0}]
[null,null,null,null,null,null,null,{"$f":"C49+D49","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(C50:G50)","v":0}]
[null,null,null,null,null,null,null,{"$f":"C51+D51","v":0}]
[null,null,null,null,null,null,null,{"$f":"C52+D52","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(C53:G53)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(C54:G54)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(C55:G55)","v":0}]
[null,null,null,null,null,null,null,{"$f":"C56+D56","v":0}]
[null,null,null,null,null,null,null,{"$f":"C57+D57","v":0}]
[null,null,null,null,null,null,null,{"$f":"C58+D58","v":0}]
[null,null,null,null,null,null,null,{"$f":"C59+D59","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(C60:G60)","v":0}]
[null,null,null,null,null,null,null,{"$f":"C61+D61","v":0}]